{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}\\file\UsersW$\wrr15\Home\My Documents\My Files\D'HAULTFOEUILLE Files\DATAVERSE FILES\TABLE2.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 1 Jun 2019, 12:39:16
{txt}
{com}. etime, start
{txt}
{com}. scalar drop _all
{txt}
{com}. import excel "\\file\UsersW$\wrr15\Home\My Documents\My Files\D'HAULTFOEUILLE Files\DATAVERSE FILES\TABLE1data.xlsx", sheet("Sheet1") firstrow clear
{res}{txt}
{com}. bysort G1: gen t=_n
{txt}
{com}. xtset G1 t
{res}{txt}{col 8}panel variable:  {res}G1 (strongly balanced)
{txt}{col 9}time variable:  {res}{col 25}t, 1 to 3
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. forvalues i = 3(-1)1 {c -(}
{txt}  2{com}. regress d.Y`i' d.D d.T1 d.T2
{txt}  3{com}. scalar Bfd_`i' = _b[d.D]
{txt}  4{com}. {c )-}
{txt}note: D.T2 omitted because of collinearity

      Source {c |}       SS           df       MS      Number of obs   ={res}         4
{txt}{hline 13}{c +}{hline 34}   F(2, 1)         = {res}     1.00
{txt}       Model {c |} {res}         .5         2         .25   {txt}Prob > F        ={res}    0.5774
{txt}    Residual {c |} {res}        .25         1         .25   {txt}R-squared       ={res}    0.6667
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    0.0000
{txt}       Total {c |} {res}        .75         3         .25   {txt}Root MSE        =   {res}     .5

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}        D.Y3{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 11}D {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}      -.5{col 26}{space 2}       .5{col 37}{space 1}   -1.00{col 46}{space 3}0.500{col 54}{space 4}-6.853102{col 67}{space 3} 5.853102
{txt}{space 12} {c |}
{space 10}T1 {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}     -.25{col 26}{space 2}      .25{col 37}{space 1}   -1.00{col 46}{space 3}0.500{col 54}{space 4}-3.426551{col 67}{space 3} 2.926551
{txt}{space 12} {c |}
{space 10}T2 {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2}      1.5{col 26}{space 2} .3535534{col 37}{space 1}    4.24{col 46}{space 3}0.147{col 54}{space 4}-2.992322{col 67}{space 3} 5.992322
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}note: D.T2 omitted because of collinearity

      Source {c |}       SS           df       MS      Number of obs   ={res}         4
{txt}{hline 13}{c +}{hline 34}   F(2, 1)         = {res}    13.00
{txt}       Model {c |} {res}        6.5         2        3.25   {txt}Prob > F        ={res}    0.1925
{txt}    Residual {c |} {res}        .25         1         .25   {txt}R-squared       ={res}    0.9630
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    0.8889
{txt}       Total {c |} {res}       6.75         3        2.25   {txt}Root MSE        =   {res}     .5

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}        D.Y2{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 11}D {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}      2.5{col 26}{space 2}       .5{col 37}{space 1}    5.00{col 46}{space 3}0.126{col 54}{space 4}-3.853102{col 67}{space 3} 8.853102
{txt}{space 12} {c |}
{space 10}T1 {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}     -.25{col 26}{space 2}      .25{col 37}{space 1}   -1.00{col 46}{space 3}0.500{col 54}{space 4}-3.426551{col 67}{space 3} 2.926551
{txt}{space 12} {c |}
{space 10}T2 {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2}        0{col 26}{space 2} .3535534{col 37}{space 1}    0.00{col 46}{space 3}1.000{col 54}{space 4}-4.492322{col 67}{space 3} 4.492322
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}note: D.T2 omitted because of collinearity

      Source {c |}       SS           df       MS      Number of obs   ={res}         4
{txt}{hline 13}{c +}{hline 34}   F(2, 1)         = {res}        .
{txt}       Model {c |} {res}          2         2           1   {txt}Prob > F        ={res}         .
{txt}    Residual {c |} {res}          0         1           0   {txt}R-squared       ={res}    1.0000
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    1.0000
{txt}       Total {c |} {res}          2         3  .666666667   {txt}Root MSE        =   {res}      0

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}        D.Y1{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 11}D {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}        1{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{space 12} {c |}
{space 10}T1 {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}       .5{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{space 12} {c |}
{space 10}T2 {c |}
{space 9}D1. {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2}       .5{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. forvalues i = 3(-1)1 {c -(}
{txt}  2{com}. regress Y`i' D G1 T1 T2
{txt}  3{com}. scalar Bfe_`i' = _b[D]
{txt}  4{com}. {c )-}

{txt}      Source {c |}       SS           df       MS      Number of obs   ={res}         6
{txt}{hline 13}{c +}{hline 34}   F(4, 1)         = {res}     9.08
{txt}       Model {c |} {res} 9.08333333         4  2.27083333   {txt}Prob > F        ={res}    0.2433
{txt}    Residual {c |} {res}        .25         1         .25   {txt}R-squared       ={res}    0.9732
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    0.8661
{txt}       Total {c |} {res} 9.33333333         5  1.86666667   {txt}Root MSE        =   {res}     .5

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}          Y3{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 11}D {c |}{col 14}{res}{space 2}      -.5{col 26}{space 2} .8660254{col 37}{space 1}   -0.58{col 46}{space 3}0.667{col 54}{space 4} -11.5039{col 67}{space 3}  10.5039
{txt}{space 10}G1 {c |}{col 14}{res}{space 2}      1.5{col 26}{space 2}       .5{col 37}{space 1}    3.00{col 46}{space 3}0.205{col 54}{space 4}-4.853102{col 67}{space 3} 7.853102
{txt}{space 10}T1 {c |}{col 14}{res}{space 2}     1.25{col 26}{space 2} .6614378{col 37}{space 1}    1.89{col 46}{space 3}0.310{col 54}{space 4}-7.154364{col 67}{space 3} 9.654364
{txt}{space 10}T2 {c |}{col 14}{res}{space 2}        3{col 26}{space 2}        1{col 37}{space 1}    3.00{col 46}{space 3}0.205{col 54}{space 4}-9.706205{col 67}{space 3}  15.7062
{txt}{space 7}_cons {c |}{col 14}{res}{space 2}     -.25{col 26}{space 2} .4330127{col 37}{space 1}   -0.58{col 46}{space 3}0.667{col 54}{space 4}-5.751948{col 67}{space 3} 5.251948
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}      Source {c |}       SS           df       MS      Number of obs   ={res}         6
{txt}{hline 13}{c +}{hline 34}   F(4, 1)         = {res}    11.08
{txt}       Model {c |} {res} 11.0833333         4  2.77083333   {txt}Prob > F        ={res}    0.2211
{txt}    Residual {c |} {res}        .25         1         .25   {txt}R-squared       ={res}    0.9779
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    0.8897
{txt}       Total {c |} {res} 11.3333333         5  2.26666667   {txt}Root MSE        =   {res}     .5

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}          Y2{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 11}D {c |}{col 14}{res}{space 2}      2.5{col 26}{space 2} .8660254{col 37}{space 1}    2.89{col 46}{space 3}0.212{col 54}{space 4}-8.503896{col 67}{space 3}  13.5039
{txt}{space 10}G1 {c |}{col 14}{res}{space 2}       .5{col 26}{space 2}       .5{col 37}{space 1}    1.00{col 46}{space 3}0.500{col 54}{space 4}-5.853102{col 67}{space 3} 6.853102
{txt}{space 10}T1 {c |}{col 14}{res}{space 2}     -.25{col 26}{space 2} .6614378{col 37}{space 1}   -0.38{col 46}{space 3}0.770{col 54}{space 4}-8.654364{col 67}{space 3} 8.154364
{txt}{space 10}T2 {c |}{col 14}{res}{space 2}-2.56e-15{col 26}{space 2}        1{col 37}{space 1}   -0.00{col 46}{space 3}1.000{col 54}{space 4} -12.7062{col 67}{space 3}  12.7062
{txt}{space 7}_cons {c |}{col 14}{res}{space 2}      .25{col 26}{space 2} .4330127{col 37}{space 1}    0.58{col 46}{space 3}0.667{col 54}{space 4}-5.251948{col 67}{space 3} 5.751948
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}      Source {c |}       SS           df       MS      Number of obs   ={res}         6
{txt}{hline 13}{c +}{hline 34}   F(4, 1)         = {res}        .
{txt}       Model {c |} {res} 7.33333333         4  1.83333333   {txt}Prob > F        ={res}         .
{txt}    Residual {c |} {res}          0         1           0   {txt}R-squared       ={res}    1.0000
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    1.0000
{txt}       Total {c |} {res} 7.33333333         5  1.46666667   {txt}Root MSE        =   {res}      0

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}          Y1{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 11}D {c |}{col 14}{res}{space 2}        1{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{space 10}G1 {c |}{col 14}{res}{space 2}        1{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{space 10}T1 {c |}{col 14}{res}{space 2}        1{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{space 10}T2 {c |}{col 14}{res}{space 2}        1{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{space 7}_cons {c |}{col 14}{res}{space 2}-4.44e-16{col 26}{space 2}        .{col 37}{space 1}       .{col 46}{space 3}    .{col 54}{space 4}        .{col 67}{space 3}        .
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. scalar list 
{txt}     Bfe_1 = {res}         1
{txt}     Bfe_2 = {res}       2.5
{txt}     Bfe_3 = {res}       -.5
{txt}     Bfd_1 = {res}         1
{txt}     Bfd_2 = {res}       2.5
{txt}     Bfd_3 = {res}       -.5
{txt}
{com}. 
. etime
{res}Elapsed time is 11 seconds 
{txt}
{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}\\file\UsersW$\wrr15\Home\My Documents\My Files\D'HAULTFOEUILLE Files\DATAVERSE FILES\TABLE2.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 1 Jun 2019, 12:39:27
{txt}{.-}
{smcl}
{txt}{sf}{ul off}